Skip to main content

Round punch time

Round the punch time to an effective time using the provided parameters.

Details

Rule Type
Time

Execution
Before punch

Parameters

NameDataTypeDefaultValueDescription
roundtointeger1Round the minutes to this nearest interval; e.g. 1=no rounding, 15=quarter hour
bumpafterinteger1When "roundto" is greater than 1, this is the break point where the minutes round forward to the next "roundto" vs backwards to the prior; e.g. 7=minutes 0 - 7 round back to zero, while minutes 8
  • 15 round forward to 15.

Decision Tree

Rule processing begins in the cell R1:Level1 and proceeds right/down. Any IF statement which results in a DONE step terminates the rule immediately.

Line#Level1Level2Level3Comment
1Start
2IF(FIND(PunchActions, Type) notin IN,OUT) Only want IN/OUT actions
3DONE
4SET(EffectiveTime = ROUND_DATETIME(PunchTime, roundto, bumpafter))Round punch to nearest "roundto"
5DONE